package com.tianyi.sfzy1.mapper;

import com.tianyi.sfzy1.domain.Coursepurchaserecord;

import java.util.List;

/**
* @author Lenovo
* @description 针对表【coursepurchaserecord(课程购买记录表)】的数据库操作Mapper
* @createDate 2025-01-02 11:46:53
* @Entity com.tianyi.sfzy1.domain.Coursepurchaserecord
*/
public interface CoursepurchaserecordMapper {

    int delete(int id);

//    批量删除
    int deleteSelect(List<Integer> list);

//    根据会员id和课程id增加购买记录
    int insertOne(int memberId,int courseId,Double purchasePrice);

    int insert(Coursepurchaserecord coursepurchaserecord);

    int update(Coursepurchaserecord coursepurchaserecord);

//    动态查询所有的购买记录
    List<Coursepurchaserecord> findCoursepurchaseAll(String title,String status,String realname);

//    小程序根据用户和课程id查询购买记录
    Coursepurchaserecord find(int memberId,int courseId);

}
